CREATE VIEW [dbo].[vGiftAidClaim]
AS
    SELECT  h.Reference as GiftAidReference,   
            RTRIM(d.TaxPayerLastName + ' ' + d.TaxPayerFirstName + ' ' + d.TaxPayerTitle) + ' [' + RTRIM(CONVERT(char(20), d.ContactId)) + ']' AS TaxPayer,
            d.TransactionPaidDate AS DateOfPayment,
            d.DonationAmount,
            d.HmrcReference,
            h.GiftAidTaxRate as GiftAidTaxRate,
            h.ClaimFromDate,
            h.ClaimToDate,
            d.IsIncludedInClaim
    FROM GiftAidClaimDetail d INNER JOIN GiftAidClaimHeader h ON d.GiftAidClaimHeaderKey = h.GiftAidClaimHeaderKey

GO